To Create a New SQL Server Database for AssetWise

Open SQL Server Management Studio (Start > Microsoft SQL Server > SQL Server Management Studio) and log in when prompted.

In the Object Explorer, under <SQLServer_computer_name>, right-click the Databases folder and select New Database.

The Database Properties dialog opens.

Do the following:

In the Database Name field, enter a name for the database. (Make sure you also write this name in the Database name field of the AssetWise installation worksheet.)
Use the Path column to change the location of the database if needed, otherwise accept the default paths.
In the Autogrowth column for the log file, set the transaction logs to be 15 to 25% of the data file; add more space if the log files are kept after the transaction is complete, for recovery purposes.
Click OK to create the database.

Note: An empty AssetWise database takes 40 MB of data. As the size of data depends on the amount of documents, associations, and index data used at a site, the best method for sizing is data from a test or training database configured to your site's specifications. If this is not possible, a small database of 100 to 200 MB will have enough space so that sizing can be accomplished at a later date.

Right-click the new database and select Properties.

In the Database Properties dialog, select the Options page and set the following:

Auto Create Statistics - True
Auto Update Statistics - True
ANSI NULL Default - False
ANSI Nulls Enabled - False
Quoted Identifiers Enabled - True
Database Read-Only - False

Note: Recovery mode can be changed if necessary.

Click OK to save any changes.